Product Search Example

This example demonstrates how to apply a search to find any products with a stock level below 100 units combined with when the last stock take was taken on the 01/12/1999.

1. From the Products window, click Search.

The Search window appears showing either a new search screen or if you have previously created a search request, the last request you created.

2. If a search is already shown, to clear this information to create a new request, choose the Discard button.

3. From the New drop down list, select the Where option.

4. From the Field drop down list, select Quantity In Stock.

5. From the Condition drop down list, select Is Less Than.

6. In the Value text box, enter the 100. Either type the value in the Value field or use the pop-up calculator.

7. To add a second condition to your request, press the TAB key to move onto the next line.

A second line appears.

8. From the New drop down list, select And.

9. From the Field drop down list, select Last Stock Take Date.

10. From the Condition drop down list, select Is Less Than.

11. In the Value box, enter 01/12/1999. Either type in the value, or select the date that you require from the pop-up calendar.

12. When you have finished setting up your search request, you can save it by clicking Save As.

13. To apply the search request, click Apply.

14. To return to the module window to view your search results, click Close.